package com.lpc.carinfo.db;

/**
 * Created by lipc0113 on 2017/11/18.
 */

public class CarInfoDb {

    public static final String CAR_INFO_TABLE = "carInfo";

    public static final String ID = "_id";//车系
    public static final String CARSERIES = "carSeries";//车系
    public static final String CC = "cc";//排量
    public static final String ENGINEOIL = "engineOil";//机油
    public static final String JILV = "jiLv";//机滤
    public static final String KONGLV = "kongLv";//空滤
    public static final String KONGTIAOLV = "kongTiaoLv";//空调滤
    public static final String QILV = "qilv";//汽滤
    public static final String HUOSAIHUA = "huosaihua";//火花塞

    public static String createTable() {

        return "create table if not exists " + CAR_INFO_TABLE + " ( " + CARSERIES + " text primary key, "
                + CC + " text, " + ENGINEOIL + " text, " + JILV + " text, "
                + KONGLV + " text, " + KONGTIAOLV + " text, " + QILV + " text, " + HUOSAIHUA + " text)";
    }
}
